<?php 
$reqPath='';
//require_once("include/authen.php");
require_once($reqPath."class/m_report.php");
require_once($reqPath.'fpdf/fpdf.php');

class PDF extends FPDF
{
	var $datefrom;
	var $dateto;
	
	function setHeaderCriteria($dtfrom , $dtto){
		$this->datefrom=$dtfrom;
		$this->dateto=$dtto;
	}
	function Header()
	{
		//Arial bold 15
		$this->SetFont('tahoma','B',12);
		//Title
		$this->Cell(0,10,iconv( 'UTF-8','cp874' , 'รายงานสั่งสินค้าจากสาขา'),0,0,'C');
		$this->Ln(5);
		$this->SetFont('tahoma','B',11);
		$this->Cell(0,10,iconv( 'UTF-8','cp874' , 'ข้อมูลตั้งแต่วันที่ '. $this->datefrom .' ถึง '. $this->dateto),0,0,'C');
		//Line break
		$this->Ln(15);
	}

	//Page footer
	function Footer()
	{
		//Position at 1.5 cm from bottom
		$this->SetY(-15);
		//Arial italic 8
		$this->SetFont('Arial','I',8);
		//Page number
		$this->Cell(0,10,'Page '.$this->PageNo().'/{nb}',0,0,'R');
	}

	//Colored table
	function GenTable($header,$data=null)
	{
		$w=array(15,95,45,45);
		$bln="";
		//header
		foreach ($data as $h){
			$this->SetTextColor(0);
			
			if ($bln != $h["BranchName"]){
				 $this->SetFont('','B');
				$this->Cell(array_sum($w),6, iconv( 'UTF-8','cp874' , "สาขา   " . $h["BranchName"] ),'',0,'L',false);
				$this->Ln();
				$bln = $h["BranchName"];
			}
			$this->SetFont('','');
			$this->Cell($w[0] + $w[3],6, iconv( 'UTF-8','cp874' , "วันที่  " . $h["_OrderDate"] ),'',0,'L',false);
			$this->Cell($w[1] + $w[2],6, iconv( 'UTF-8','cp874' , "เลขที่่ใบสั่งของ  " . $h["OrderNo"]) ,'',0,'L',false);
			$this->Ln();

			//Colors, line width and bold font
			$this->SetFillColor(20,114,218);
			$this->SetTextColor(255);
			$this->SetDrawColor(114,175,242);
			$this->SetLineWidth(.1);
			$this->SetFont('','B');
			
			for($i=0;$i<count($header);$i++){
				$this->Cell($w[$i],7,iconv( 'UTF-8','cp874' , $header[$i]),1,0,'C',true);
			}	
			$this->Ln();
			
			
			//Color and font restoration
			$this->SetFillColor(224,235,255);
			$this->SetTextColor(0);
			$this->SetFont('');
			//detail
			$fill=false;
			$i=1;
			foreach ($h["Detail"] as $d){
				$this->Cell($w[0],6, $i ,'LR',0,'R',$fill);
				$this->Cell($w[1],6,iconv( 'UTF-8','cp874' , $d["ProductName"]),'LR',0,'L',$fill);
				$this->Cell($w[2],6, number_format( $d['Amount_s'] ,2,'.',','),'LR',0,'R',$fill);
				$this->Cell($w[3],6, number_format( $d['Amount_c'] ,2,'.',','),'LR',0,'R',$fill);
				$this->Ln();
				$fill=!$fill;
				$i++;		
			}
			$this->Cell(array_sum($w),0,'','T');
			$this->Ln(15);
			// AddPage();
		}
 
	}
}

if (!(isset($_POST['dFrom']))) {
	header("location:report_branch_order.php");
}

	$datefrom = $_POST['dFrom'];
	$dateto = $_POST['dTo'];
	
	list($day, $month, $year) = split('/', $datefrom);
	$c_from =$year."/".$month."/".$day;

	list($day, $month, $year) = split('/', $dateto);
	$c_to =$year."/".$month."/".$day;

	$branch = $_POST['branch'];

	$report=new M_report();
 // $c_from="2011/03/01";
 // $c_to="2011/03/31";
 // $branch=0;
 
	$data=$report->BranchOrderReport($c_from, $c_to, $branch);
	$header=$report->BranchOrderHeader();
	if (count($data)==0){
	echo "<script>alert('Data not found');window.close();</script>";
	exit();
}
//echo $data;
	$pdf=new PDF();
	$pdf->setHeaderCriteria($datefrom,$dateto);
	$pdf->SetRightMargin(5);
	$pdf->SetLeftMargin(5);
	//Set pageno
	$pdf->AliasNbPages();
	$pdf->AddFont("tahoma","","tahoma.php");
	$pdf->AddFont("tahoma","B","tahomab.php");

	$pdf->SetFont("tahoma","B",10); 
	$pdf->SetFont("tahoma","",10); 

	//Data loading
	$pdf->AddPage();
	$pdf->GenTable($header,$data );
	 $pdf->Output();
	exit();
 
?>
